Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

ICTPRG554 Mapping and Delivery Guide
Manage data persistence using noSQL data stores

Version 1.0
Issue Date: May 2024


Qualification -
Unit of Competency ICTPRG554 - Manage data persistence using noSQL data stores
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to implement a data store and manage data persistence using non structured query language (NoSQL) to provide automatic scaling as well as high performance and availability over semi-structured data.The unit applies to those working as senior software developers, senior back end developers or full stack developers, and responsible for managing information and communications technology (ICT) in small-to-large enterprises (SMEs).No licensing, legislative or certification requirements apply to this unit at the time of publication.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.

Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.

This includes access to:

an open source or commercial NOSQL database

the internet, including connectivity

required hardware, software and applications.

Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.

Prerequisites/co-requisites
Competency Field
Development and validation strategy and guide for assessors and learners Student Learning Resources Handouts
Activities
Slides
PPT
Assessment 1 Assessment 2 Assessment 3 Assessment 4
Elements of Competency Performance Criteria              
Element: Review and select noSQL options
  • Confirm use and application for noSQL according to business requirements and needs
  • Research and compare horizontal and vertical scaling and confirm relevance and benefit of horizontal scaling according to business requirements
  • Research and compare noSQL technologies and traditional relational data models
  • Research, review and select noSQL vendor technologies according to business requirements
       
Element: Determine and create storage of data types
  • Design and determine data storage requirements from noSQL data store according to selected vendor technology and business requirements
  • Review and select required types of noSQL data store according to business requirements
  • Create partition key and determine storage place of data items
  • Review and determine required partition key and ensure effective distribution of storage across partition
       
Element: Build and configure indexes
  • Determine and select required sort key according to business requirements
  • Calculate, determine and configure read and write through-puts according to business requirements
  • Determine, configure and create indexes for optimising data retrieval queries
  • Determine and create additional indexes
  • Optimise data queries and retrievals for indexes according to business requirements
  • Determine and configure time-to-live (TTL) on data objects according to business requirements
       
Element: Use queries and retrieve objects
  • Research and select required API client for interacting with noSQL data store according to business requirements
  • Substantiate and connect API client to noSQL data store instance
  • Insert single data object into noSQL datastore using selected client application
  • Insert multiple items in single operation
  • Use query and select single object
  • Use query and retrieve multiple objects in batch
  • Perform query against index
  • Perform query to select required attributes and project results
       
Element: Confirm interaction of objects
  • Delete single and multiple objects according to business requirements
  • Update single and multiple objects according to business requirements
  • Persist objects with different data types
  • Configure and confirm change event triggers and notifications according to business needs
  • Test, fix and ensure responses and trigger notifications work according to business requirements
  • Review and confirm data is encrypted and authorisation and authentications are active according to user and client access requirements
  • Test and fix data persistence process according to business requirements
  • Document and finalise work according to business requirements
       


Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

create at least three different queries, including updating, deleting and creating data types

create at least two indexes.

In the course of the above, the candidate must:

specify partition and sort keys

optimise the data.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

benefits and functions of noSQL database and schema free data persistence, as well as traditional relational data models

methods and different features and functions between scaling out and scaling up (horizontal and vertical)

language used in required programming language for noSQL applications

partitioning in a noSQL environment and its related terms

functions and features for time-to-live (TTL) requirements

authorisation and authentications procedures and levels of responsibility according to client access requirements

distribution of data storage across partitions

debugging and testing methodologies and techniques

functions and features of sort keys in noSQL storage

features of transport encryptions, authentication and authorisation

different noSQL data store formats, including:

key value

document based

column based

graph based

different noSQL data types, including:

numeric

string

boolean

complex

date time.


Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)


Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Confirm use and application for noSQL according to business requirements and needs 
Research and compare horizontal and vertical scaling and confirm relevance and benefit of horizontal scaling according to business requirements 
Research and compare noSQL technologies and traditional relational data models 
Research, review and select noSQL vendor technologies according to business requirements 
Design and determine data storage requirements from noSQL data store according to selected vendor technology and business requirements 
Review and select required types of noSQL data store according to business requirements 
Create partition key and determine storage place of data items 
Review and determine required partition key and ensure effective distribution of storage across partition 
Determine and select required sort key according to business requirements 
Calculate, determine and configure read and write through-puts according to business requirements 
Determine, configure and create indexes for optimising data retrieval queries 
Determine and create additional indexes 
Optimise data queries and retrievals for indexes according to business requirements 
Determine and configure time-to-live (TTL) on data objects according to business requirements 
Research and select required API client for interacting with noSQL data store according to business requirements 
Substantiate and connect API client to noSQL data store instance 
Insert single data object into noSQL datastore using selected client application 
Insert multiple items in single operation 
Use query and select single object 
Use query and retrieve multiple objects in batch 
Perform query against index 
Perform query to select required attributes and project results 
Delete single and multiple objects according to business requirements 
Update single and multiple objects according to business requirements 
Persist objects with different data types 
Configure and confirm change event triggers and notifications according to business needs 
Test, fix and ensure responses and trigger notifications work according to business requirements 
Review and confirm data is encrypted and authorisation and authentications are active according to user and client access requirements 
Test and fix data persistence process according to business requirements 
Document and finalise work according to business requirements 

Forms

Assessment Cover Sheet

ICTPRG554 - Manage data persistence using noSQL data stores
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:


Assessment Record Sheet

ICTPRG554 - Manage data persistence using noSQL data stores

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: